AmElectronicLeads

Logical Entity Name | AmElectronicLeads
Default Table Name | AmElectronicLeads
Physical Only | NO
Owner | dbo
Definition |
Note |

AmElectronicLeads Columns

ColumnName | Domain | Datatype | NULL | Definition
AmElectronicLeadsID |  | int | NO |
SSN |  | char(11) | YES |
LastName |  | varchar(128) | YES |
FirstName |  | varchar(128) | YES |
MI |  | char(1) | YES |
Addr |  | varchar(255) | YES |
City |  | varchar(25) | YES |
State |  | varchar(2) | YES |
SyCountryID |  | int | YES |
Zip |  | char(10) | YES |
Phone |  | char(16) | YES |
WorkPhone |  | char(16) | YES |
Sex |  | char(1) | YES |
AmRaceID |  | int | YES |
AmTitleID |  | int | YES |
AmMaritalID |  | int | YES |
DOB |  | datetime | YES |
Age |  | tinyint | YES |
AmCitizenID |  | int | YES |
email |  | varchar(128) | YES |
AmLeadSrcID |  | int | YES |
AmLeadTypeID |  | int | YES |
SyCampusID |  | int | YES |
AdProgramID |  | int | YES |
Comment |  | varchar(2000) | YES |
AmExtraCurrID |  | int | YES |
AdProgramGroupID |  | int | YES |
AdTermID |  | int | YES |
AdGradeLevelID |  | int | YES |
UserDefined |  | varchar(4000) | YES |
Status |  | char(1) | YES |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
HSGradYear |  | varchar(4) | YES |
BestTimeToContact |  | varchar(10) | YES |
AmSexID |  | int | YES |
AmNationalityID |  | int | YES |
DrivLicState |  | char(2) | NO |
DrivLic |  | varchar(20) | NO |
AlienNo |  | char(9) | NO |
AmAgencyID |  | int | YES |
AmRepID |  | int | YES |
AdShiftID |  | int | YES |
StartDate |  | datetime | YES |
AmPrevEducID |  | int | YES |
AmHighSchoolID |  | int | YES |
AmCollegeID |  | int | YES |
HSGradDate |  | datetime | YES |
PLEmployerID |  | int | YES |
PlEmpStatusID |  | int | YES |
Disabled |  | char(1) | NO |
Vet |  | char(1) | NO |
OtherPhone |  | varchar(16) | YES |
OtherEmail |  | varchar(128) | YES |
Suffix |  | char(3) | YES |
MiddleName |  | varchar(100) | YES |
HSGraduated |  | bit | NO |
HSGraduationSession |  | varchar(10) | YES |
HSDateEnrolled |  | datetime | YES |
HSLastDateAttended |  | datetime | YES |
HSStudRank |  | int | YES |
HSSchoolSize |  | int | YES |
HSTranscriptType |  | tinyint | YES |
HSStudLevel |  | tinyint | YES |
LeadVendor |  | ntext | YES |
Keyword |  | ntext | YES |
IsHispanic |  | char(1) | YES |
MobileNumber |  | varchar(16) | YES |
AmSuffixID |  | int | YES |
PreferredName |  | nvarchar(50) | YES |
NickName |  | nvarchar(50) | YES |

AmElectronicLeads Primary and Unique Keys

Key Name | Key Type | Keys
AmElectronicLeads_Status_SyCampusID_AmLeadSrcID_AdProgramID_DateAdded_HSGradYear_AmElectronicLeadsID_U_N_IDX | Index | Status, SyCampusID, AmLeadSrcID, AdProgramID, DateAdded, HSGradYear, AmElectronicLeadsID
AmElectronicLeads_AmElectronicLeadsID_U_C_IDX | PrimaryKey | AmElectronicLeadsID

AmElectronicLeads Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
AmSuffix | Non-Identifying | Zero or One to Zero or More | FK_AmElectronicLeadsAmSuffixID_AmSuffixAmSuffixID |  |  | AmSuffixID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
AmElectronicLeadsUserValues | Non-Identifying | One To Zero or More | FK__AmElectro__AmEle__70EB7669 |  |  |  | NO | YES
AmElectronicLeadsAmRace | Non-Identifying | One To Zero or More | FK_AmElectronicLeadsAmRaceAmElectronicLeadsID_AmElectronicLeadsAmElectronicLeadsID |  |  |  | NO | YES
AmElectronicLeadsSyPersonGenderPronoun | Non-Identifying | One To Zero or More | FK_AmElectronicLeadsSyPersonGenderPronoun_AmElectronicLeadsID_AmElectronicLeads_AmElectronicLeadsID |  |  |  | NO | YES

AmElectronicLeads Check Constraints

Check Constraint Name | CheckConstraint

AmElectronicLeads Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group | PRIMARY

AmElectronicLeads Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.PendingProspectInquiry | NO |  |  |
Physical (Microsoft SQL Server) dbo.AmElectronicLeads | NO |  |  |

AmElectronicLeads Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Prospect
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Admissions

AmElectronicLeads Data Movement Rules

Name | Type | Rule Text/Value